You are here: 2. General Ledger > 2.4. GL TRANSACTIONS Menu: Posting Transactions > 2.4.6. GL Transactions - External Ledgers Report

GL Transactions - External Ledgers Report

Transactions are automatically posted from MDS to MGL in real time according to the way your GL integration is setup. However, the accumulating totals of all transactions in MDS are stored in the external file awaiting transfer to the General Ledger. The End of Day (EOD) program in MDS is used to extract and consolidate GL data, providing an audit trail of the transactions that have been posted to the General Ledger. It can also be used to update the Creditors Ledger.

 

Reference

For information on the End of Day process in MDS, refer to "End of Period - End of Day".

During the End of Day process, users can select whether to print the GL External Report (i.e. all transactions in the external file). This is an audit trail of all transactions updated from the Distribution system and the Creditors Ledger to the General Ledger since the last time an EOD was processed. It forms part of your audit trails.

Alternatively, you can print the External Report using this option within the General Ledger. If you have not run this report before, ensure that you print it to PDF as it could be very large.

  1. Select GL TRANSACTIONS | EXTERNAL LEDGERS REPORT.

Micronet displays the External Transactions Report screen.

  1. Select either:

Micronet displays the Select Report screen with a list of report layout options created in the Report Generator.

  1. Select a format for the report then select Ok.

Micronet displays a User Defined Questions screen.

  1. Complete the following fields:

 

Field

Value

 

Enter Starting / Ending Period No

If you want to include a specific period range in the report, select the starting and ending periods. Leave these fields blank to include all periods.

 

Enter Starting / Ending Date

If you want to include a specific date range in the report, enter or select the starting and ending dates. Leave these fields blank to include all dates.
  1. Select the Ok button.

Micronet displays the Select Output Device screen.

  1. Select whether you want the report displayed on screen, printed, saved to a specific type of file, faxed, or emailed in a specific format.

 

Reference

For more details on these options, refer to "Selecting the Output for Inquiries and Reports".

Micronet prints or displays the External Report in the selected report layout.

General Ledger Interface - By Account